UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oNStRNeRF0yzz1NWEyQHVPaBRm/03R2O9JemNLxEkFo='
WHERE
key_id = '8e6f5ab472232a1fd2772e305e480a0ac529d4821ab4f0bffde139e1149b4cf1'
AND (
token = 'oNStRNeRF0yzz1NWEyQHVPaBRm/03R2O9JemNLxEkFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)