UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JXOxL8CUawOZ1ILHWH1EoEvmniEhJgF0YeVO5jdwwFw='
WHERE
key_id = '4bd24cfe5176e85177341a2ee0dd20c7d59ca08349b4bb111c30c6cc7fc2aeaa'
AND (
token = 'JXOxL8CUawOZ1ILHWH1EoEvmniEhJgF0YeVO5jdwwFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)