UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zIL/zc+I9+5k55eOTYzVDXKRT7xCz5mH0TuXLAwbl40='
WHERE
key_id = '4fd9afd8112675e650e96c717c02411f20602bb97677cdf103005dcf7c9b2a21'
AND (
token = 'zIL/zc+I9+5k55eOTYzVDXKRT7xCz5mH0TuXLAwbl40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)