UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JIPsdtoCC5S8bWwDccZztqKMvUd/q8IYkjMqYK558Mw='
WHERE
key_id = '8a7ae1f93b22697878ff9ebd0c12ee8b0521d9d613816c6b674428633452b14a'
AND (
token = 'JIPsdtoCC5S8bWwDccZztqKMvUd/q8IYkjMqYK558Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)