UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/d9Y8y9Fl19T+c79MBTN+UKxhrcJ9ijAEFHbtM79CsM='
WHERE
key_id = 'fbc965ffb663a8603df67ad03345b65d6b524c2013f4e4c15412e48599e5f2b5'
AND (
token = '/d9Y8y9Fl19T+c79MBTN+UKxhrcJ9ijAEFHbtM79CsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)