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