UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Njh8e8KEDZkzY//oLt1r1sINAIfKF3rPojPTQK0Kr1Q='
WHERE
key_id = 'e0ffc48e61ec300991a2adcd2fb22d100a2490ee14b2464ebc1230d27de725aa'
AND (
token = 'Njh8e8KEDZkzY//oLt1r1sINAIfKF3rPojPTQK0Kr1Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)