UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGScFpAoQkT5exuZw4H2us75QT5JzwiKryEio2ibhk8='
WHERE
key_id = '1d7d2aa986df376c9cd248be86403b85d6fe837c64d990d5bb2b4a2f853e21e8'
AND (
token = 'XGScFpAoQkT5exuZw4H2us75QT5JzwiKryEio2ibhk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)