UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '34zxXAQLxKrBsobpZnrERf1jkdm/PjUWkkFtlyre9ss='
WHERE
key_id = 'd2aadfa2edccf4ea6d458f60345a5bf74efed0ae1012b3905ccf5fa4a24ea8dd'
AND (
token = '34zxXAQLxKrBsobpZnrERf1jkdm/PjUWkkFtlyre9ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)