UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/X9PMFzZE3TaiBiPLWp4eaU6m2qN7Vu/me5Of8Lqo4Y='
WHERE
key_id = '53ec005c9e71a83f6eec4940075a514da89fc92226ea888ca92b711224b5ba7b'
AND (
token = '/X9PMFzZE3TaiBiPLWp4eaU6m2qN7Vu/me5Of8Lqo4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)