UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gMe4t0rzcH75sQYVCpkSklVbTroOugA30q/3nfDqIlw='
WHERE
key_id = 'd5cdda8a32f50145fdb67686d44c9e86bdfe5518dee7e3cf85834c651bc050e0'
AND (
token = 'gMe4t0rzcH75sQYVCpkSklVbTroOugA30q/3nfDqIlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)