UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0OGZDFHUF2l5w6Op3vKMC0C6VO5ta4ckKPLXsMc9i+c='
WHERE
key_id = '471675e3f37de46be2e7d0efd754529c26b19c4fcf1364ecef7a89c4f28892b7'
AND (
token = '0OGZDFHUF2l5w6Op3vKMC0C6VO5ta4ckKPLXsMc9i+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)