UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gciM9/awciGQKTa4Xl6rB0JG77LzxwfBbupv9/flCu8='
WHERE
key_id = '50b01e05967f15fa61daa25d1b6e046795aaf740c634cd754cc0a9ccac924693'
AND (
token = 'gciM9/awciGQKTa4Xl6rB0JG77LzxwfBbupv9/flCu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)