UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rsn7YFGnO5xTnup52mTZEhYFmo8y+J+QJR0xdGVQeuA='
WHERE
key_id = '2a9a8beed348e7bb077a6175932a346240927c09e2ef6448b63497d9c35953a5'
AND (
token = 'Rsn7YFGnO5xTnup52mTZEhYFmo8y+J+QJR0xdGVQeuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)