UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oL61Gh1m6WAVAwGJ/uTj87CBHikhTfVv330OcMyccnI=' 
WHERE 
  key_id = 'c744e56f69f380e9072c954b0f834758415a800a9c67b728f540ee9a1da6d014' 
  AND (
    token = 'oL61Gh1m6WAVAwGJ/uTj87CBHikhTfVv330OcMyccnI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032