UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x/rfKxyQXjXIIMkbKnoPWC8fZt9RDU7cV5A5a8ivsHI='
WHERE
key_id = '97aac6c6c7b1203add0d3bc4718cc765ec96675076f4d56f3f132a7a3146b63a'
AND (
token = 'x/rfKxyQXjXIIMkbKnoPWC8fZt9RDU7cV5A5a8ivsHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)