UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hiLyv4OsU190S1BGfafOdqNwVyP0yAVgoHR0aR2Cs3Y='
WHERE
key_id = '97def8aed7200313a58263688dcd4993835ec93a64ba522235f658480f1903b1'
AND (
token = 'hiLyv4OsU190S1BGfafOdqNwVyP0yAVgoHR0aR2Cs3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)