UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZOcyVXE1RNHcWL1kFy6BZRJc1bcW5Lib2ffOOS2h+EA='
WHERE
key_id = '21ee3e8b8beec04caffffb539697688beda6587052450467ee6df2689254be2e'
AND (
token = 'ZOcyVXE1RNHcWL1kFy6BZRJc1bcW5Lib2ffOOS2h+EA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)