UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CmbWa+YUM2Of5bd3YDUZw8EpSsyF2cZIsV2QkIjxxe4=' 
WHERE 
  key_id = 'd466e6e9d1073d0b8f092343166f70fb1bef2fa1c72b996087319febcedd065a' 
  AND (
    token = 'CmbWa+YUM2Of5bd3YDUZw8EpSsyF2cZIsV2QkIjxxe4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037