UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QhVPfcyM86ZagDLkOmK7Zlzb3ed17QHxYj/15qY/DcA='
WHERE
key_id = 'c24acc1dc494cca54597809c6a894f85975026324aa832a14292286a5548cb62'
AND (
token = 'QhVPfcyM86ZagDLkOmK7Zlzb3ed17QHxYj/15qY/DcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)