UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QLpvQlDLhJ2lF1g1ufm23MUryRfQe3FoVLp/irKmatM='
WHERE
key_id = '1e7b64de8dc7060f1212b1b1f69fdab46967868169efc7e01f32535f93a89dd1'
AND (
token = 'QLpvQlDLhJ2lF1g1ufm23MUryRfQe3FoVLp/irKmatM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)