UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ozwdjgr317YksfwBGw4RuIGW2mdn3zrS2YKmMsznwP0=' 
WHERE 
  key_id = '6d652dd4c9a700e5bb9c071dc2b8898f21aad0ffe7197e654da11f0f5f7fc8fb' 
  AND (
    token = 'ozwdjgr317YksfwBGw4RuIGW2mdn3zrS2YKmMsznwP0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041