UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6RGH85C8nkmE/D/XGj4WX3yyzJYh41PK/2P+VmB29N8=' 
WHERE 
  key_id = 'df5be4b9cb49d1a0f7e80aaef523cf1b00f149ecf0a503e76bf4370a077088be' 
  AND (
    token = '6RGH85C8nkmE/D/XGj4WX3yyzJYh41PK/2P+VmB29N8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035