UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e7E6z0JRBvKCsEIVerjt3g0bBcnWK0srbu9Hgez+Mu8='
WHERE
key_id = 'a647d5f407d6820a8f331c0c9201e4eed4c07fad96b1b1e9eec632a7339a9717'
AND (
token = 'e7E6z0JRBvKCsEIVerjt3g0bBcnWK0srbu9Hgez+Mu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)