UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L7XG2OFxOe6ZaM/54j4Lu9XHycJnVvQ1BdhJhxh5lXw='
WHERE
key_id = '7b6cc707fb26a698040eabbe5a00d41b4fee045e21ca44ab8c0b54c4a0ea6be6'
AND (
token = 'L7XG2OFxOe6ZaM/54j4Lu9XHycJnVvQ1BdhJhxh5lXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)