UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8bw9aj2wkPNUkYUWZsnBbbji9qFtZx4sNHO8fjEcVI='
WHERE
key_id = 'b54b7f949afe4793798fd5be88e4f70c9944dbc68b26bdcf3ccddf1e00fd5d21'
AND (
token = 'k8bw9aj2wkPNUkYUWZsnBbbji9qFtZx4sNHO8fjEcVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)