UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TS5qjzUK6xY3eE+wsnUvizPIOOilAoAz4nMms+RllVI='
WHERE
key_id = '1e11ed381e7e7a6faed2f3964ccc76a306e13e354a69e8d828ee7f73d26af890'
AND (
token = 'TS5qjzUK6xY3eE+wsnUvizPIOOilAoAz4nMms+RllVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)