UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gexIc9vS8IwbWEIgiYEsF/z01l1lKNE0UjMktAXsMQs='
WHERE
key_id = '6468edf13e2d9cb1996c05ce5354f7a5d7c96d73971c5beca311c5b5b3e7812b'
AND (
token = 'gexIc9vS8IwbWEIgiYEsF/z01l1lKNE0UjMktAXsMQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)