UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'noJULmCNc7dJmG1fvOVghGCU6PfB52CX/al7Z431KwI='
WHERE
key_id = 'b288214e0c77a76bcc3d678b6a16143a376796ad8d4e5625b2f2a92a493e340a'
AND (
token = 'noJULmCNc7dJmG1fvOVghGCU6PfB52CX/al7Z431KwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)