UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nhh+VBPh3COtcODqzMfDvJpc24/YoPijhOng0Q6UE4Y='
WHERE
key_id = 'fd9509a83b25ab95344958f9161fe8dab0d707883de0106eac0f5cfb1b945418'
AND (
token = 'nhh+VBPh3COtcODqzMfDvJpc24/YoPijhOng0Q6UE4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)